alter table jms_dm.dm_network_deliver_miss_scan_rate add columns
(     config_str string comment'共配、驿站补推、共配/驿站补推'
)cascade;

alter table bidefault.dm_network_deliver_miss_scan_rate add columns
    (     arr_pistol_id string comment'到件扫描设备',
          outwarehouse_pistol_id string comment'出仓扫描设备'
)cascade;

alter table bidefault.dm_network_deliver_miss_scan_detail add columns
    (     customer_code string comment'客户编码',
          customer_name string comment'客户名称'
)cascade;


alter table jms_dws.dws_network_deliver_miss_scan_detail add columns
    (     arr_pistol_id varchar(30)  comment'到件扫描设备',
          outwarehouse_pistol_id varchar(30)  comment'出仓扫描设备',
          store_code varchar(30) comment'门店编码',
          store_name varchar(120) comment'门店名称',
)cascade;
--------------------------
alter table bidefault.dm_network_deliver_miss_scan_rate add columns
    (     customer_code string comment'客户编码',
          customer_name string comment'客户名称'
)cascade;


alter table jms_dws.dws_network_deliver_miss_scan_detail add columns
    (     arr_pistol_id varchar(30)  comment'到件扫描设备',
          outwarehouse_pistol_id varchar(30)  comment'出仓扫描设备',
          store_code varchar(30) comment'门店编码',
          store_name varchar(120) comment'门店名称'
)cascade;

alter table bidefault.dm_network_deliver_miss_scan_detail add columns
    (     arr_pistol_id varchar(30)  comment'到件扫描设备',
          outwarehouse_pistol_id varchar(30)  comment'出仓扫描设备',
          store_code varchar(30) comment'门店编码',
          store_name varchar(120) comment'门店名称'
)cascade;